Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
BrandName (PK) | A unique name to denote a class of ITEMs as a product. The brand can include private label ITEMs. | NM_BRN | Name | varchar(40) | |
OwningPartyID (FK) | A unique, system assigned identity for a Party. | ID_PRTY | Identity | integer | Party(PA_PRTY) |
Description | The description of a class of ITEMs produced by a product of a single supplier or manufacturer. | DE_BRN | DescriptionShort | varchar(255) | |
BrandGrade | A retailer designated code that indicates the relative value of the brand within its portfolio of brands. This is imporant when comparing brands offered by a retailler for sales analytic and customer segmentation purposes. Examples: PREMIUM - high quality brand SUPERIOR - better quality brand REGULAR - middle of the road brand VALUEPACKAGE - inexpensive no frills brand LOWEND - Lowest price brand | CD_BRN_GRDG | Code | varchar(20) | |